USE CourierDatabase
GO
INSERT INTO Emp_Decentralization VALUES('President') 
INSERT INTO Emp_Decentralization VALUES('Administrator')
INSERT INTO Emp_Decentralization VALUES('Enquiry Department')
INSERT INTO Emp_Decentralization VALUES('Working Department')
INSERT INTO Emp_Decentralization VALUES('Dispatch Department')

INSERT INTO Working_Status VALUES('On probation')
INSERT INTO Working_Status VALUES('Working')
INSERT INTO Working_Status VALUES('On leave of absence')
INSERT INTO Working_Status VALUES('Quit')

INSERT INTO Secure_Question VALUES('What is your favourite cartoon ?')
INSERT INTO Secure_Question VALUES('Where do you want to travel to ?')
INSERT INTO Secure_Question VALUES('When did you have your first kiss ?')
INSERT INTO Secure_Question VALUES('Who do you love the most ?')
INSERT INTO Secure_Question VALUES('What is the name of your primary school ?')

--user : EMP000000  password : 123456
INSERT INTO Employee(Emp_Id,Emp_Name,Emp_Address,Emp_Phone,Emp_Mail,Status_Id,Decentralization_Id,Login_Name,Login_Password,S_Question,S_Answer,Time_Created) VALUES(0,'Linky','New Delhi',0122438694,'couriermanagementproject@gmail.com',1,0,'EMP000000','e10adc3949ba59abbe56e057f20f883e',0,'Inuyasha','8/23/2013')
INSERT INTO TempTable VALUES(1,1,'8/23/2013')

INSERT INTO Point VALUES('New Delhi')
INSERT INTO Point VALUES('Jaipur')
INSERT INTO Point VALUES ('Itanagar')
INSERT INTO Point VALUES('Mumbai')
INSERT INTO Point VALUES('Panjim')
INSERT INTO Point VALUES ('Dispur')
INSERT INTO Road VALUES(0,1,260)
INSERT INTO Road VALUES(0,2,2200)
INSERT INTO Road VALUES(0,5,1960)
INSERT INTO Road VALUES(0,3,1400)
INSERT INTO Road VALUES(0,4,1860)
INSERT INTO Road VALUES(4,3,560)
INSERT INTO Road VALUES (4,1,1750)
INSERT INTO Road VALUES (2,5,325)

INSERT INTO Charges VALUES (30,5)
INSERT INTO Charges VALUES (50,8)
INSERT INTO Charges VALUES (60,12)
INSERT INTO Charges VALUES (70,25)
INSERT INTO Charges VALUES (90,35)

